Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The right tablestructure, or is there a better way?

Status
Not open for further replies.
Mar 27, 2002
168
NL
I need output like this:
First floor:
behind the door:
1 <plant1>
1 <type1>
in front of window
1 <plant2>
1 <type2>
Second floor:
near to elevator:
1 <plant1>
1 <type1>
and so on.
So I make 3 tables.
tblLocation: location_id, loc_description (first, second floor)
tblSubLocation: subloc_id, loc_id (fk), subloc_description (behind the door, in front of window)
tblDetails: details_id, subloc_id (fk), plant_id, type_id, plant_count, type_count

It seems not to be so difficult, but my problem is:
How can I build a form where people can put the information this way?
In a continuous form it's not possible to make a subform. But I think, I need 2 continuous subforms,
I hope somebody can help me,
Thnx in advance,
Gerard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top