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

 

[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."