I have a couple of tables in my database that contain various account numbers and codes that are all related to one another. I was wondering if creating an array would work to get the associated account numbers to appear on a form depending on which dept code is being used.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using arrays
- Thread starter SHAWTY721
- Start date
SkipVought
Programmer
Hi,
Why create an array? Why not put that information in a table relating "account numbers and codes that are all related to one another."
Then use that table in your joins.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
When a wee mystic is on the loose..It's a Small Medium at Large!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question