[gamecockfan]

You will have a junction table to link the two.

Would I need just one junction table that connects all three tables (Movie Table, Customer Table, Checkout Table), or a junction table only to connect the Customer Table and Checkout Table?

[jimr381]

The junction table will be the checkout table. It will hold the primary keys for the Customer and the Movie table along with the checkout/checkin date.

[AcaCandy]

After you guys get this all set up, can you email me a copy?

[jimr381]

Originally Posted by AcaCandy

After you guys get this all set up, can you email me a copy?

It will cost you.

[gamecockfan]

Originally Posted by jimr381

The junction table will be the checkout table. It will hold the primary keys for the Customer and the Movie table along with the checkout/checkin date.

That makes sense. I have the junction table setup as you described. Thanks.

[gamecockfan]

Originally Posted by AcaCandy

After you guys get this all set up, can you email me a copy?

It will cost you big.

[gamecockfan]

In your opinion, how would you do the Checkout form? Would you place another tab on the main form where the user can select a customer, and the checked out items display in a subform or just place a form on a second tab that shows all records?

[jimr381]

I would probably do a subform within another tab or at the bottom of the main form.

[gamecockfan]

I was kind of thinking another tab as well.

[AcaCandy]

That would be my tab Put it on my tab

[gamecockfan]

Originally Posted by AcaCandy

That would be my tab Put it on my tab

LOL....You got it!

[gamecockfan]

I am not sure of the best way to create the new tab.

I was planning to make the cboTitle combobox visible property set to false, and then have a cboCustomer combobox that will have a visible property set to true. However, the main form is tied to the qryMovie query.

Would this be a good path to continue down?

Please review the attached database.

[gamecockfan]

I was thinking that using the existing cboTitle dropdown box on the main form would be better than trying to hide one and make another visible. What do you think?

However, I cannot get the cboTitle dropdown box to work for both tabs, When I select a title from the dropdown box, the form keeps jumping to the first tab.Also, the dropdown box is not populated with the first selection when the form is first opened.

[jimr381]

The drop-down will be fine for selecting. You would want to check and see if you could actually add records to the sub-form or see if would be setup as read-only since it is piggybacking off of a query.

[gamecockfan]

Would it be better to create a separate query?