Hi everybody.
I'm an access beginner trying to make a simple data base to help me plan and produce concerts.
A short description of the problem in my project is as follows.
I have table employe_data containing info of employes data: name, mobile, email.
Table concert_data contains details of the concerts i'm planning: eg, artist, date, time etc.
In table concertd_data i would like to do multible lookups in different fields to table employe_data to assign employes a various task in the concert:
concert_artist
concert_date
concert_time
booking_responsible look up into table a getting name, mobile, mail off person a
production_responsible look up into table a getting name, mobile, mail off person b
This works great for 1 person only with a many to one relationship from table concerts (many) to table employe (on), but person b's data never arrives.
So in short my problem is that I want many fields to look up data in the same table and return info for the various look ups.
this might be a beginner problem, but hey... thats what i am ;-)
Any ideas of a proper design?
greetings