date dublicated

[zuglchaim]

I have 2 tables
1 has fields 1. "child ID", 2. "dates"
field "dates" is a look up from different table which has 2 fields 1. "date ID" 2."dates", and field "dates" is what stored in the first table

how whould i programm that child ID should not have dublicate "dates", when someone whants to enter dublicat it whould return error massege

very importent
by the way with your help, everybody, i have finished my datebase a head of time and this is my last problem
thank you all

 

[PWise]

what is it that you want?
not to be able to have 2 the same date in the date field then create an index on the field "No Duplicates"
but if what you want is that one child should not have 2 records with same date then on view menu select indexes
on the form that pops up in the first column enter a name
in the 2nd column on the first line select the first field
(child) in the lower left set unique to yes
in the 2nd row select the 2nd field (dates)
save the table
now you drink to the compition of your datebase and zug a pur lchaims
and much hatzloch with your next project

 

[zuglchaim]

lchaim lchaim!!! much hatslocha to you too