Hi,
I am struggling with something which seems pretty basic...
I have a main form 'Booking' (parent item) and a subform 'Booked_Item' (child items). Each Booking may contain several Booked_Item's.
I can easily enter details into both form and subform - this works very well.
What I am struggling to do is produce a simple grid which includes one column for each field entered into both the Booking Form and Booked Item Subform.
My thoughts on what could be the cause of problem (THIS MIGHT BE COMPETENTLY ON THE WRONG TRACK):
This could be because I have not understood how to link the data correctly in the subform to the main form - I have not been successful in creating a lookup in the subform 'Booked_Item' based in the 'Booking' ID in the main Form. It appears that the
Booking.
ID is only created after the record is saves so I can't work out how to ensure that
'Booked_Item'
successfully
points to Booking.ID. Any suggestions on how to address
this would be useful too.