Ok, Well, I won't be much help if you have to enter everything for 7 tables on one form. I use one driving form, then pull up a new form for any new area that they need to enter. Dan
At 04:20 PM 2/11/2004 -0500, you wrote: >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 >
