limiting 8 records to 1 field

[andywilko101]

i need to limit 8 records to one field. im not really sure what im doin so
ill give an example of what i need to do.

each adivsor specialises in up to 8 holidays. a holiday can be assigned to
many advisors but it cannot be assigned twice to the same advisor.

thanks if u can help.andy

 

[BruceM]

You need to provide more information. What is the real-world situation
behind your question? How is your data base set up? While you're at it,
use standard English writing conventions, or a good number of people here
will ignore the question.

 

[Jerry Whittle]

You need three tables as you have a Many-to-Many relationship:

Advisors (with something named like AdvisorID as the primary key)

Holidays (with something named like HolidayID as the primary key)

Adv_Hol with the combination of the AdvisorID and HolidayID as the primary
key or at least a unique constraint. That way an Advisor can only be assigned
to a particular Holiday one time. You enter the combination of Advisors and
Holiday combinations into this table. If you accidentally try to give the
same advisor the same holiday more than once, Access will complain.