Automatically Copy some values from Another Table to a certain table (HELP)
Newbie here. I have this products. This picture shows my Product Table
Now, I want to add them directly to OrderDetails Table after adding them to my Products Table (picture above). How can I do that? Just like how the values in OrderDetails Table is linked automatically to Orders Table (another table with concatenation of Order ID column and OrderDetail ID column on OrderDetails Table )
Is this possible? Automatic linking of data from Products Table to OrderDetails Table ? What formula do I need?