You will need to create a Form to hold your Main Table data, but when creating the Subforms, the Wizard will allow you to directly choose a Table as each ones Source.
Making a Form for each Table, then using that Form as the Source for the Subform, has the advantage of giving you more control over how the data is entered, but in a simple application this isn't always needed.
As I said before, your cryptic Field names makes it difficult to guess exactly what you're doing here, but it would seem, superficially, to be relatively straightforward for the tbllvl1, tbllvl2 and tbllvl3 Tables.
The similar names of the Fields of each Table also makes me wonder about the normalization, or rather lack of normalization, of your data, but that, too, is impossible to gauge, given what we've been presented with.
You might want to check out CyberCow’s list of links on the subject of Normalization. The list appears on Post #5 of this link:
http://www.utteraccess.com/forum/Use...-t1986675.html
Linq ;0)>
.
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
Windows XP 
Access 2007
Reply With Quote
