I have created a Database with some related tables say Customer and order and they are joined with the CustID i have created the main form and the subform and linked them together.
My problem is if i say put in the key where they are joined for the 1st time its appearing on the subform (which is good) and is picking up the other linked fields BUT when i open the actual table (for the subform) they are no records in there.
The other things i m trying is to search a fields for duplicates using wildcards without specifying or pre-defining the text say like *ons* etc but because i dont know the names @ hand and i want say if they are mispelled drug names to be flashed as possible dupes and they will then be sorted manually - is it possible to achieve??
any help will be greatly appreciated