M
micromoth
I have a form with a one to many relationship with one field in another
table this works fine when the table is full. It basically works as a
lookup table on the form which is what I want.
Problem:
Firstly when I want to leave this field on the form blank as it is not
relevant for an individual record input is blocked. Secondly is when
the table is empty and no number is available to be selected again
input is blocked. Any ideas welcomed, Thanks in advance
table this works fine when the table is full. It basically works as a
lookup table on the form which is what I want.
Problem:
Firstly when I want to leave this field on the form blank as it is not
relevant for an individual record input is blocked. Secondly is when
the table is empty and no number is available to be selected again
input is blocked. Any ideas welcomed, Thanks in advance