A
Adrian John
I am trying to develop a database that has one parent table to many children
tables.The parent table uses a sequential ID number e.g starting at 1000 and
child tables have their own 6 figure number based on name i.e Mary's numbers
begin with 299 Jill's 101 and so on. How do I get Access to combine and
select the next available 'empty' child number entry based on the childs name.
e.g
Parent 1000 Mary 299100
Parent 1001 Mary 299101
Parent 1002 Jill 101000
Parent 1003 Mary 299102
Parent 1004 Jill 101001
Hope this makes some sense.
tables.The parent table uses a sequential ID number e.g starting at 1000 and
child tables have their own 6 figure number based on name i.e Mary's numbers
begin with 299 Jill's 101 and so on. How do I get Access to combine and
select the next available 'empty' child number entry based on the childs name.
e.g
Parent 1000 Mary 299100
Parent 1001 Mary 299101
Parent 1002 Jill 101000
Parent 1003 Mary 299102
Parent 1004 Jill 101001
Hope this makes some sense.