Click here to Skip to main content
15,888,454 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a basic purchase order database in access 2016

There is a table called ItemData which has a autonumber key column ItemDataID, then ItemType, ItemManufacturer, ItemDescription, ItemCost.

In the Order Table there are various fields for supplier, delivery etc.
Then I want to be able to put in 5 order lines.

If there was only one line there would be no problem.

However I want to have ItemData1, (with all the other requsite fields as per above), then ItemData2 etc to ItemData5.
Of course for the relational DB to work the key have to be the same so changing then names will not allow it to connect (I think!).

How can I link the data from Item table to the 5 inputs needed on the Order table.

What I have tried:

Google, YouTube, Bashing brains on desk...
Posted
Comments
Mohibur Rashid 26-Jun-18 20:04pm    
Poor Desk, he had to deal with your bashing. Jokes aside, I failed to understand your problem. Which I really want.
Richard Deeming 27-Jun-18 11:15am    
Any reason you can't have a "proper" design, with an OrderLines table for a many-to-many relationship between orders and items?

(And welcome back, BTW! Is the political career on hold now?)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900