Thanks guys! Basically, I have four tables. They are for TV, Radio, Print,
and Internet; all advertising. All contain client specific data. Some
clients show up in more than one Table, but many are just in one Table.
Right now I use a Form to query for a client, by entering the client’s last
name. Results are displayed in a ListBox. I double-click the client that I
am looking for (several clients could have the same last name), and results
are transferred to another Form. Some client-specific info is displayed
here, as well as ‘notes’, which are basically entered by a person who has a
conversation, or some kind of discussion, with the client. That’s pretty
much it. This concept works fine on one Table now, and I’m just using two
Forms to query from that Table and write (updating the Notes) back to the
Table. I’m wondering if this is the best way to do this. I was thinking of
having four buttons on the Form, so I can pick and choose which Table I’m
querying from and writing to. Does it make sense? Is there a better way to
do this?

Thanks for everything!
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Fred" wrote:

If you need additional help beyond the above......

I would suggest starting with fundamental structure, and start by describing
the fundamental "entities" that you want to database and the relationships
between them. To avoid your description getting derailed and avoid
misconceptions that could result in a non-description, I would start by
describing the above without using any Access or Excel terminology.