Multi field entry from form

[liam_898]

Looking for some advice.

I would like to create a form where multiple values can be added to a table in one go.



This is for my table 'tbl_supplier_purchases'. This table holds all product purchases from suppliers. What I would like is to be able to select one supplier, and add many product, and then input many records for that one supplier.

here is a print screen of my relationships:


The product ID and supplier ID are lookups so the user selects names rather an IDs.

no idea how to go about this.

Any suggestions would be appreciated

[June7]

Consider a form/subform arrangement.