Quote:



If I'm reading this correctly...

You have an order form with a line items subform. You want to enter a customer number and have the subform automatically prefilled with the set of items this cutomer normally orders.

Is this correct?

Assuming that you have the following databases:
Customers
Items
Orders

I'd put a Profile keyword field in Customers where you store a semi-colon separated list of the item numbers for each Customer.

In Orders, once you select a Customer, use XLookup to get the Profile value for that Customer. Now you have a StringArray.

Write a loop that uses AccessStringArray to get each item in turn. For each item, XLookup the name, price, etc. for that item. Use @FormNewRecord to create a line item subrecord for each item.

You can then delete those subrecords you don't want. Alternately, you can use @AskUser to confirm each item before adding it. Or, you can set it up where you can select a particular item to add from the list or ALL. Once you have the list of items, it really becomes a question of what exactly you want to do with it.