Reply to thread

Message: [QUOTE="Rick B, post: 2549736"] sounds like you need to redo your links (relationships). The two tables must be combined based on a unique field. Obviously, last name is not unique. You need to use a customer number, or the combined Last and First names. I'd recommend customer number. Rick B I have set up a database with a members table and a payments table. I need to be able to apply payments to an individual member... all goes well until members have the same last name, then the payment posts automatically to both members. The tables are linked by the namelast data field. I have tried setting up a combo box which combines namelast namefirst parentname Thought this would differentiate between last names by including first names but it doesn't. Any thoughts or suggestions greatly appreciated! [/QUOTE]