Search results

after thinking about it more, we definatly need two tables. one with idnumber, name, address info 2nd with idnumber, gift amount, date information. data entry will provide idnumber to 2nd table, name will then be shown on the form after the idnumber is matched back to Table1 (for QC'ing...

yea I hear you about the search, i'm just not sure exactly the terms i should be searching on. I understand all about relational databases. THe problem I'm finding is that all the tutorials and information I find on two linked tables in a database has both tables containing the same contactid...

i thought i understood how it is done, two tables connected via an idnumber field. or perhaps one table that has an idnumber field and the dataentry person then keys in some IDnumber and it brings up that idnumber's other fields to be edited, viewed, etc.

the whole point is to save time on data entry. data entry person keys in the ID number and that record pops up so that they can then enter the "response date" and "amount" information to the proper record without entering in the entire record and possibly miskeying anything.

any ideas?

sure, i'll try to make it as simple as i can. I dont think i'm explaining it right. table: mailed fields: contactid, name, keycode table: responses fields: contactid, name, keycode, dateresponsed, amount The form will show the RESPONSES fields. so if i have table: mailed record: 001...

when i try and click "Enforce referential integrity", i get the message "no unique index found for the referenced field of the primary table" i have "donor information" table and a "responses" table. Responses table is empty. Can I not use referential integrity if the fields are empty? When...

the purpose is for mail that's returning. to track donations, responses, things of that nature. we have the entire file we mailed, which will be the matchback table. we'll be building a new table, using the idnumber from the response on the mailpiece, and logging what they responded with. if...

I have what I think is a fairly simple idea but can't seem to find the solution. we have a table1 filled with idnumber, name, address info. we have a 2nd table that's empty. data entry person should open up form, type in an idnumber (that will match up to the idnumber on table1) and it will...