Table checking

[west72]

hi hope someone can help. i'm new to access and have created a simple database for work.

what happens is i enter the client then media.
but the problem is that it is posible to mix up the clients and medias. IE client1 goes with media 1 and so on but it is posible to enter client 1 and media 2.
is there a way of getting access to check to make sure you can't mix up clients and medias.

sorry if it does not make sense.

 

[Jack Cowley]

You are right in that it does not make sense to me. Can you give a step by step example of how clients and media are involved during data entry or exactly what it is that you are doing?

Jack

 

[Pat Hartman]

If only a single media type goes with each client, store the media type in the client table and don't enter it for each transaction. If there are multiple media types associated with each client, you'll need to create a table to store this information. Then use this table as a lookup value in a combo to restrict the media choices in your transaction form.

 

[west72]

i print files for different clients and the database stores the amount i print and displays a report with the totals.

the form has the following

Client
Media
Number of Files
Number of Pages

ie if i may have 4 files of bexley (client),bxa4(media),120 pages, then later 3 files bexley,era4,120 pages

this is then displayed at the end of the night .

Bexley
era4,3x120 pages
bxa4,4x120 pages

the problem is if someone enters westminster,bxa4.
this media does not exist for this client.

what i need is for access to check the client and media and not allow any that are mixed up.

i hope this have made it a bit more clear.

 

[Jack Cowley]

I think Pat Hartman, in her infinite wisdom, has solved your problem with this answer, "If there are multiple media types associated with each client, you'll need to create a table to store this information. Then use this table as a lookup value in a combo to restrict the media choices in your transaction form."