enter new data in linked tables

[ujaymailing]

Table 1 has the diferent sale dates for each case.
Table 2 has the address for each case.
I have a column in table 2 to check for each time a case mailed.
Problem: I cannot enter or change data in table 1 or 2.
? how do I put the tables togather to enter or change data ?
if I can do that I could probably then make a table 3 for mailed cases.
Thet get cancelled alot and rescheduled for sale many times

 

[MGFoster]

Table 1 has the diferent sale dates for each case.
Table 2 has the address for each case.
I have a column in table 2 to check for each time a case mailed.
Problem: I cannot enter or change data in table 1 or 2.
? how do I put the tables togather to enter or change data ?
if I can do that I could probably then make a table 3 for mailed cases.
Thet get cancelled alot and rescheduled for sale many times

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You need a column in both tables that holds the same data, like a
CaseID. Then you'd use the CaseID column as the linked (related) column
when you join the tables. The same would go for the third table.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSU8vhYechKqOuFEgEQLfdACg8RiyM4b6uHD+oj2L/YFFdyfXmpsAn0b1
a/biYn4HjTgOuKsSSf3VY+4S
=VHnB
-----END PGP SIGNATURE-----