More than 1 linked form to master form.

[jam]

Part 1 of 2

OK my relationships are setup and look really sexy so I'm happy with them.

I have 1 main form called land. This holds all the physical info on the peices of land.
Onto this I need a linked form for land owners. (this can be done under a normal wizard in Access).
But i also want to write notes on the progression of the planning permission on the land itself. These are logged onto a different table in a many to many relationship (this works perfectly).

But I cannot find out how to link the land form and these 2 other forms by buttons.

But I also need to add another linked form containing more information which specifically relates to the land itself.

I've gone through the help files on access and the northwind database and I'm struggling to do what I need it to do. It maybe very easy to do and I'll probably look like a fool by asking the question, but somethings only easy when you know how.

Thanks inadvanced.
Jam

 

[HiTechCoach]

Jam,

You can use multiple sub forms, a separate one for each related tables.

I like to use a TAB control to organize the sub forms.

 

[jam]

Thanks for the reply, I'm still at a bit of a loss.

I don't understand how I'd create 2 sub forms off the main form. These subforms are not datasheets type of inputs they need to be another form. Then part 2 of this mess will be creating a subform for the subform.

~head ache~

Thanks
jam

 

[jam]

OK I can see why you'd want to use a TAB Control to organise the details but heres a bit of info that might help explain my situation a bit better.

My land table is many to many with the owners table.
(Many owners may own 1 peice of land and many peices of land my belong to one or more owners.)

My land table also has a one to many relationship with a landnotes table. This keeps notes on any peice of land and logs the times and dates of their input.

My land table also has an attachments table (access 2003) by way of one to many relationship. Which I may want to attach PDF's, JPG's and other documents to a peice of land.

My owners table has a one to many relationship with a ownersnotes table.
(Notes being taken by owner for which there maybe many many notes)

The form needs to display the Land table as the main form. Everything eventually references in our business to a peice of land.
On this form I need subforms of...
>Owners Form > Owners notes
>Land notes
>Attachments

To put all these on to 1 form would be impossible and I don't want the data being shown as a table but rather as a seperate form.

What I need to know is how do I go about making these forms and linking them to the master form IE Land form?

Cheers in advanced
jam

 

[jam]

BTTT

Still need help!

 

[namliam]

You can nest subforms... if that is your question...
Main form > Subform1 > Subform2 > Subform3

Just use the "add subform" wizard and you shoudl be good to go...