Hi,
I have Table A with a record say called A1
I also have Table B that has a 1 to many relationship that has say 4 records in it. Inside that table I have a whole number column called position.
So Table B has the following records
Name TableARecord. Position
B1 A1 1
B2 A1 2
B3 A1 3
B4 A1 4
B5 A1 5
I need to make sure that position is only ever used once BUT only relating to the related record
So if I was to create another record in Table B against at A1 record with a position of 2, I would get a error message.
Hope this makes sense.
Wondering what best approach to solving this would be?
Thanks in advance
Todd