Possibly I might be able to help, it sounds as if we have somewhat the same sort of table setup. I have 32 tables that keep data for 18,000 customers, (Owners) that have 22,000 jobsites (buildings) with over 30,000 pieces of equipment... etc.
All billing would point to an owner (custid in the Main table)
All Jobsite info points to an owner (custid in the Main table)
All Equipment info points to a Jobsite (Jobid in jobsite table)
All Service call info points to Jobsite (jobid in jobsite table)
etc...
Not everything points to the main table, yet nothing exists without a link back to the main table through a chain of links.
Are you trying to do everything with just one form?
At 01:06 PM 2/11/2004 -0500, you wrote:
I am having difficulty linking tables and maintaining referential integrity. I have 7 tables to store information that I need. (down from 12) I have separated the information the best i can into the fewest tables I can use. My problem is this....I build a form to enter/edit data. My primary table (the one that everything keys to) will only let me enter data into the primary table and one other table, and be able to recall the info correctly using an outer join. The rest of the tables are locked out. When I go to those fields I cannot enter anything. I have tried a dummy table and this limits me to one table. When I base the form on the primary table I get the above problem. I think my problem lies in my tables and how they are keyed. I have read all the examples that come with Rbase and they really don't apply. I'm not dealing with customer products and sales but, rather, addresses, businesses, names and building features. Any suggestions (be nice) would be greatly appreciated. Thank you.
Dan Champion www.championsolutions.net
