Split forms

[GCS]

Hello... This is my first post so please be patient with me.

I work for a Christian school and am designing a database to track our auction items. I have two tables: Items (one record per each item donated with a unique Item# for each) and Lots (one record per lot up for auction - some auction lots are multiple items that have been bundled to make one lot). Tables have a one (lot) to many (items) relationship.

I have designed an lot form but would like it to be a split form with the bottom half showing only the items that have the same lot ID#.



Can I do it in a split form or do I need to use a subform? If I can do it with both, which is better to use?

Thanks for any help you can give me!

[June7]

I don't like split form and avoid it.

If you want to be able to edit fields from both tables, need to do a form/subform arrangement.

I guess a split form can have a subform. You could try.

[dblife]

Sounds like a great project!
You can do this by basing a form on a select query.
How?
Create a form of all the lots in single form view.
Then, go create a new query from the table with the lot ID's and in the criteria box for the lot ID write Forms![FormFromPreviousStep]![LotID]
Use this new query to create a new form in Datasheet view called 'fSelectedLot'.
On the form from step one, create a button using the wizard to open 'fSelectedLot'
When you run it normally, hitting this button should allow you to see only the items in the lot you have chosen.

[GCS]

Thanks!!!