access2003 and bank account tables.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make three tables:
Main_Account (6 digits)
Sub_ACC_1 (7 digits)
Sub_ACC_2 (8 digits)
The main account number is also the first 6 digits of the subs.

Main_Account 123456
Sub_ACC_1 1234567 (last digit is always 7)
Sub_ACC_2 12345670 (last digit is always 0)

Can the Main_Account automatically fill the lower accounts? How?
Thank you
 
I need to make three tables:
Main_Account (6 digits)
Sub_ACC_1 (7 digits)
Sub_ACC_2 (8 digits)
The main account number is also the first 6 digits of the subs.

Main_Account 123456
Sub_ACC_1 1234567 (last digit is always 7)
Sub_ACC_2 12345670 (last digit is always 0)

Can the Main_Account automatically fill the lower accounts? How?
Thank you
Click to expand...

If the suffixes are always 7 and 70, then you don't need either fields or
tables for either one! Just append the appropriate suffix.

Am I missing the point here? Is there information stored about a subaccount
which is different than the information in the main account? Do some main
accounts have subaccounts and some don't? Or does each main account always
have two subaccounts?

John W. Vinson [MVP]
 
They don't always have subs but at least one sub_account and being new to db,
I wasn't clear on how to "automate" filling those fields.
 
They don't always have subs but at least one sub_account and being new to db,
I wasn't clear on how to "automate" filling those fields.
Click to expand...

Sub_Acc1: [Main_Account] & "7"
Sub_Acc2: [Main_Account] & "70"

John W. Vinson [MVP]
 
Thank you.
Now I'll get back to reading.


John W. Vinson said:
They don't always have subs but at least one sub_account and being new to db,
I wasn't clear on how to "automate" filling those fields.
Click to expand...

Sub_Acc1: [Main_Account] & "7"
Sub_Acc2: [Main_Account] & "70"

John W. Vinson [MVP]
Click to expand...
 
Back
Top