Table advise

  • Thread starter Thread starter myxmaster
  • Start date Start date
M

myxmaster

I have a table that has the following
ID
Account
Category
Limit

Each account may have only 1 item from each of the categories and 1
limit, for example:
Credit = $5000
Cash = $1000
Check = $2000

Not:
Credit = $5000
Credit = 2000
Credit = 1000 and so on


At present the table I have allows each account number to have
multiple accounts of each category.

TIA
 
I have a table that has the following
ID
Account
Category
Limit

Each account may have only 1 item from each of the categories and 1
limit, for example:
Credit = $5000
Cash = $1000
Check = $2000

Not:
Credit = $5000
Credit = 2000
Credit = 1000 and so on


At present the table I have allows each account number to have
multiple accounts of each category.
Click to expand...

Use the Indexes tool; type a distinctive name in the left column
(UniqueCategory say). Select the Account field in the right column next to the
name, and the Category field in the next row down:

UniqueCategory Account
Category

Check the Unique Values checkbox and save the index, and you'll only be able
to insert one record for each account-category pair.

John W. Vinson [MVP]
 
Back
Top