|
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.
|
Title: Message
