Using arrays

[SHAWTY721]

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.

 

[SkipVought]

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,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}