Hi all,
I am currently working on an invoicing system, and have gotten most of the functional requirements I had set met comfortably save for one. the order forms I am trying to create are a many to many relationship between the inventory table and the order numbers table. in between I have a table containing the order ID as well as the item name, I need that table to complete the rest of the item information (item ID, description, price, etc.) from the item name and populate the link table fields. Ideally that also should happen in a subform. I have so far tried to do this with a table and with a query, neither have worked very well, but the query is the closest I have managed to get so far.
I can send further context as soon as I can, I just need to make a copy of the database that wont Dox me
thank you in advance
I am currently working on an invoicing system, and have gotten most of the functional requirements I had set met comfortably save for one. the order forms I am trying to create are a many to many relationship between the inventory table and the order numbers table. in between I have a table containing the order ID as well as the item name, I need that table to complete the rest of the item information (item ID, description, price, etc.) from the item name and populate the link table fields. Ideally that also should happen in a subform. I have so far tried to do this with a table and with a query, neither have worked very well, but the query is the closest I have managed to get so far.
I can send further context as soon as I can, I just need to make a copy of the database that wont Dox me
thank you in advance