Yes, I am trying to use the tabbed form for ease of use for the person entering data. I need to keep it as simple as possible. If they have to close a form and open another to continue with the same record set, they will inadvertently omit information. I'm trying to make it as dummy-proof, errr... Error-resistant as possible.
-----Original Message----- From: Dan Champion [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 11, 2004 17:17 To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: table integrity Neil, 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
