One to many (BookingID) not replicating to other tables

[Dega]

Attached is the db.

tblBookings.BookingID is not being replicated to tblBookingDetails.BookingID

Other future tables (tblRooms) will also need this BookingID?

Many customers book several times a year and use different products.

Not much different than a sales database showing customer purchases (lifetime history).

Thanks

[RuralGuy]

Foreign keys are not populated in tables where they exist unless you do it or are using a Form/SubForm and it is the LinkMaster/ChildField of the SubFormControl.

[June7]

Use form/subform arrangement. Review http://office.microsoft.com/en-us/ac...010098674.aspx

[Dega]

I have two subforms (tabs) and may have more in the future.

So far I can only get one subform to work properly and tried numerous times.

Thanks

[June7]

The posted db did not show form/subform arrangement. If you want us to analyse your effort, provide that version.

Have you set the Master/Child links properties of the subform container control?

[RuralGuy]

Do you have that ForeignKey as your LinkMaster/ChildFields entry?

[Dega]

Sorry ... I thought that version I sent had the two subforms.

Main Form: frmCustomers
Sub Form: frmBookings
Sub Form: frmBookingDetails

Each customer will always have the same CustID but that customer may book several times per year.

CustID gets populated in the tblBookings from the main form no problem there.

This is where my problem is ... because there is no option available to link (subform) frmBookings.BookingID with (subform) frmBookingDetails.BookingID.

LinkMaster/ChildFields only point to the main form (frmCustomers) on frmBookingDetails.

I will have another table (tblRooms) that will most likely need the BookingID as well.

Thanks

[June7]

Sorry, the form/subform arrangement was there, was just too tired I guess.

Forms can be nested up to about 7 levels. So form/subform/subsubform could be

frmCustomers/frmBookings/frmBookingDetails.

Only the bottom form can be continuous or datasheet view, all higher levels would be single view.

Linking Bookings and BookingDetails side-by-side requires a special technique. Review http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[Dega]

I will try that again ... and hoping that the value will be entered in the table (tblBookingDetails) and not just visible on the form (frmBookingDetails).

I gave that a try before and was stuck.

Thanks

[Dega]

June 7,

That technique worked after getting the propert syntax correct ... thanks.

I have a few more forms to deal with and have included another version of the db (attached).

Issue: Some forms not populating with values. (below)

1) tblBookingDetails Subform
RoomID


Not certain how to go about this with the one-to-many relationships I have defined.

tblTours is being used for a query ...

Thanks for your help.

[June7]

1) Where should it update from? Don't you have to enter a RoomID? Why is there a subform for tblRooms?