I was wondering if a Db design guru could provide guidance for a db newb??
I have to design a database (and front-end app) that contain ID reference numbers that relate to groups of additional numbers.
ID No. 1124 (ref A) contains 30 numbers (ref B) 01, 02, 03 ect up to 30
ID No. 1101 - contains 60 numbers 01, 02, 03 up to 60 ect
ID No. 1411 - contains 70 numbers 01, 02 up to 70
ID No. 1024 - contains 20 numbers
ID No. 1045 - contains 50 numbers
ID No. 1058 - contains 40 numbers
ID No. 5214 - contains 120 numbers
ID No. 7845 - contains 160 numbers
and so on
The Ref B groups of numbers can vary in size and need to be raised and lowered as and when needed.
I'm assuming that each second set of numbers (ref B) need to have individual unique identifiers , but how would I go about creating and mapping to the first group of (ref A) numbers??
Any pointers appreciated.