R
r
Hello again. I can't get the other problem resolved completely, so I'm
going to try another solution, but still have questions since what I've
tried isn't working.
I want to use a combo box for my user to select the record details they'd
like to view on the form. The list of record IDs is stored in table1, and
the details are in table2 (one record in table2 for each ID in table1).
How can I set up my form so that the user can select the ID from the combo
box (from table1) and have the related detail record (from table2) display
on the form - BUT - if there is no related detail record, a new record would
be created in table2.
If there is a tutorial on this online, please point me to it. I couldn't
easily find anything in a search.
Thanks! Hopefully I'll get into the swing of this soon.... : {
going to try another solution, but still have questions since what I've
tried isn't working.
I want to use a combo box for my user to select the record details they'd
like to view on the form. The list of record IDs is stored in table1, and
the details are in table2 (one record in table2 for each ID in table1).
How can I set up my form so that the user can select the ID from the combo
box (from table1) and have the related detail record (from table2) display
on the form - BUT - if there is no related detail record, a new record would
be created in table2.
If there is a tutorial on this online, please point me to it. I couldn't
easily find anything in a search.
Thanks! Hopefully I'll get into the swing of this soon.... : {