how can I

[macamarr]

Hello,
I have a form, what I would like to do is; When I select a record from the form, have it paste/populate in some sort of a list/subform. I just don't know what I need to do. Thanks!

 

[Ziggy]

You wouldn't want to, or need to paste the data. What you would do is build a subform. eg in an Order entry type form you might have an order Header for the customer name then a subform for the order details.

The Subform has an ID for each record that is equal to the order header, so when a record from the order header is selected the details are also displayed. A relationship is created between the 2 fields.

Order Header (Table)

headerID
Name
Address


OrderDetail (Table)

OrderDetailID (id fror the details)
HeaderID (ID reference equal to Header table)
Product
OrderQTY

I'm kind of rushing a little but read up on "Subforms" in Help. Repost if your still stuck and I or someone else should be able to help.


Ziggy