Tab

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Im building a database which I think in theroy should be easy but of course
Im stuck! :-0

The database is nothing more than a daily activity log. The way I'm
designing it will be one form with a tab. The form or top half will have the
name datea and shift the person is working. The tab will contain line items
representing the activity (one activity per line).

So I have the top created (form log_main) and a tab with a sub-form
(sub_log)containing the data. Then I tried to connect them but realized
rather quickly that I have one main record with multiple sub records. So I
know there is a way to link this, but being the newby I am, I'm blanking out.
Ideas? Suggestions?

Thanks,
 
Im building a database which I think in theroy should be easy but of course
Im stuck! :-0

The database is nothing more than a daily activity log. The way I'm
designing it will be one form with a tab. The form or top half will have the
name datea and shift the person is working. The tab will contain line items
representing the activity (one activity per line).

So I have the top created (form log_main) and a tab with a sub-form
(sub_log)containing the data. Then I tried to connect them but realized
rather quickly that I have one main record with multiple sub records. So I
know there is a way to link this, but being the newby I am, I'm blanking out.
Ideas? Suggestions?
Click to expand...
look at the data property of the subform. you'll need to match a
priamry key field from log_main to a foreign key field on sub_log.
 
Back
Top