Perplexed 1

[macgus234]

I'm an access newbie and have been charged with developing a supervisor call list for my work.

tbl_supervisor
id, lname, fname, home_phone, cell_phone, pager


tbl_lineup
date, central_gas_super, central_serv_super, east_gas, east-serv_super

I'm having trouble in trying to relate the two tables so that I can run a report by date to list each oncall supervisor by area. Maybe I've been staring at this too long but any help in setting up the relationship between the tables would be greatly appreciated.

thanks!

 

[Blorf]

Because your line up table has each position in a different field, it will be very difficult indeed to link them.

I suggest a table structure for the line up.

ID
Super_Position
Date

Then, you can link on the ID field, and be on your way.

Should you need to view the data as you listed above, use a cross tab query.

ChaZ

Ascii dumb question, get a dumb Ansi

 

[macgus234]

...thank-you for such a quick reply