Hi,
I'm building an Invoice system for a cattle farm. It consists of the main form and a sub-form where i select the cattleID that are to be sold. The CattleID is a look-up field (whose data source is tblCattle).
The weakness is when i've selected say CattleID '55-107', i go to the next record entry on the subform...the same cattleID appears again from the lookup field list and so it could be entered in twice! One idea was to use an update query ?? but i wouldn't know how this could be done.
I've been reading a wee bit about subqueries...but again, i wouldn't know if i'm on wrong path? Any help on this would be much appreciated...if a solution exists.
Thanks
t