Can a Table Call Itself?

[HenryE]

Hi All,

I just created a table where one field uses another field in the same table as a combo box. Namely, I have a table called Clients, with two fields: ClientName and CurrentClientName. ClientName has all possible names, recent, old, you name it, for clients. CurrentClientName calls ClientName using a combo box lookup. So a user can choose the current client name from among all names in ClientName (I hope all this makes sense).

So far, it seems to work. The question is: Am I making a huge mistake by doing this? Having a table call itself seems like a recipe for something going wrong down the road, but I'm not sure how. Is there a better way (using a view, for example?)?

Thanks.

Henry

 

[Norris68]

So you have a combo box bound to the Clients.ClientName field with a record source of something like "SELECT DISTINCT ClientName FROM Clients"? Nothing wrong with that, although you won't be able to add any new client names if you limit your combobox to the list. A view is only a query that is saved in an optimised state - slightly better performance.

 

[HenryE]

Thanks much.

Henry