relate form information

[firewall_ie]

Hi Can someone have a look at this database, I am try to relate the main form information to sub information in differnt forms. Please help me. CAn I mail it to someone as it is a little to big for upload to this service. I will repay somewhere along the line of my life of computers.

Regards

Aaron Browne

 

[Idjit]

Hi Aaron,

You'll probably have better luck posting the db than asking to e-mail it. You can decrease the size of it by deleting data from the tables and any forms that don't relate to your question, running a "compact and repair", then zipping it.

It's hard to know what you're asking for without seeing the db, but in general, to relate information between main and subforms, you need to make sure that 1) the relationships between the tables is properly set up and 2) the Link Master and Link Child Field properties of your forms are specified correctly.