auto numbers to main reference number

=?Utf-8?B?QWRyaWFuIEpvaG4=?=

Guest

Posts: n/a

23rd May 2006

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.

« Populate a listbox with psudo-data | Normalisation - any quick guides to this? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Generate account numbers with Auto number	Jacqueline	Microsoft Access Database Table Design	10	11th Aug 2008 10:39 PM
Obtain Sub-Report page numbers in reference to main report	Larry.Bargers@wellsfargo.com	Microsoft Access Reports	3	23rd Feb 2007 08:18 PM
auto numbers to main reference number	=?Utf-8?B?QWRyaWFuIEpvaG4=?=	Microsoft Access	1	27th May 2006 03:56 AM
find closest match to a reference number in a row of numbers	=?Utf-8?B?TmljayBLcmlsbA==?=	Microsoft Excel Misc	4	21st Dec 2005 11:59 AM
Turning sequential numbers into an Auto Number Field	=?Utf-8?B?TGF1cmFL?=	Microsoft Access	2	18th May 2005 02:22 AM