Forms & Records

[Guest]

Visual Aid: www.gotmerchant.com/curtis/access.gif

I know this is backwards, but...

I have a customer db, and when I create a record in FinanceInfoDetails
before I do anything in the FinanceInfo, it wont carry over the FinanceInfoID
with it (in forms of course), unless I do something in FinanceInfo
table/form. Like update a field, etc. Is there a command I can use in one
of the events that would requery it or something, so when I start typing a
record in FinanceInfoDetails, it will automatically grab the FinanceInfoID
without having to give that table focus first.

Does that make sense?

Thanks
Curtis

 

[Guest]

I really is backwards. You should create a FinanceInfo record first.

 

[Guest]

I dont know of any other way to do it because FinanceInfo has one record
while FinanceInfoDetails can have multiple records for each FinanceInfo
record.