Thanks - I will use the word tool - I find that cleaner and makes people laugh more!
Well it basically rolls on from your previous post about breaking the first normal form. As you said that one customer has many dispositions. So separated the tables and made a tbldispositions and tblcustomers. I want to make a form that allows me to drag and drop fields from both tables BUT it wants to "assign" itself to one or the other and won't sit as an "Unrelated Object"
Its probably the most n00b like question but Im pretty sure in 2003/2002 I was able to do it...
Last edited by BackForBreakfast; 08-19-09 at 12:04.
Ok - if you are going for the two table approach then you want to use a form and subform. Essentially, your person record provides the "header" information on the "parent" form. The sub form contains all the dispositions for that person (i.e. it would display several disposition rows).
Of course, this assumes you were taking my advice and splitting the table in to two.