Project Chronicle (Structure)

[jonnywakey]

Hi

Im looking for some guidance on what may be a simple task but I cant seem to get it to function correctly within my database.

I have a table which has a primary key field called ID, this table called tblTop_Lvl
contains project top level data.

When data is entered into the table via the form, i'd like to be able to link multiple lines of data to each top level ID through a sub-form called tblSub_Lvl.

So in theory when viewing the top level form on the chronicle tab (Navigation Form) the user can enter muliple lines with an ID and this is linked only to the top level ID number.

Top Level ID Sub Level ID
1 1.1
1.2
1.3
2 2.1
2.2
2.3

Hope this makes sense.

Thanks

Jonny

 

[CJ_London]

just use a subform for your tblSub_Lvl data