OK on simple joins, I use queries to link tables and then build forms so that users can add data etc. However I am having trouble doing this for complex relationships! I have:
Personal(Id, name)
personal_Address(Id, addressId, type)
Address(addressId, .... )
Institution(InsId, name, addressId...)
Uni(insId, grade...)
College(insId, grade...)
School(InsId, grade...)
I have normalised this so that Uni/school/college have a main table instituiton, which uses address table shared with personal_table..
Now what I would like to do is to create a query that would show data even if incomplete so that I can then use that query to create forums!
Is that how you build forms? or is there a different way?
Personal(Id, name)
personal_Address(Id, addressId, type)
Address(addressId, .... )
Institution(InsId, name, addressId...)
Uni(insId, grade...)
College(insId, grade...)
School(InsId, grade...)
I have normalised this so that Uni/school/college have a main table instituiton, which uses address table shared with personal_table..
Now what I would like to do is to create a query that would show data even if incomplete so that I can then use that query to create forums!
Is that how you build forms? or is there a different way?
