How would you Handle this with a Form

[AcctRecDB]

I have Four tables, CustomerTBL(holds all the customers for both companies); NoteTbl; AgeingTBL1 (this is for one company) ;AgeingTBL2 (this is for a child company)

I need to keep the 2 ageings seperate.

I want to creat a form from the customer table (so you can make edits to contact info and such)

Then I would like a subform with the ageingtbl1 and the note table to be linked together, but I only want the records from the customer table and note table to come back that match the ageing for that perticular customer.

I think I made this more confussing then it needs to be

 

[misscrf]

I hate to do this to you, but I would redo the aging tables...

agingtypeTBL

auto
type - child, company


agingTBL
auto
fktotypetable
age


then work on forms.

Here is a link on normalization. People usually resist it, but those who follow it have 500% less confusion and more clarity in setting up their db and reaching their goal.

http://www.utteraccess.com/forums/s...r=373096&page=0&view=expanded&sb=5&o=&fpart=1

This link is my savior. It taught me how tables work, and how queries should be used, how forms are created, everything.

 

[AcctRecDB]

That makes perfect sense to me thanks...