Form Design

[traycee]

I have a form based on a client table and it is linked to a form based on the session table. One client to many sessions and it works fine. However, we also have clients that ask for help that remain anonymous. No client information but they do have session information. I'm trying to decide what would be the best way to handle that. Currently, they can just click the session button, which is on the client form, and just fill in session and skip the client form totally. A report is generated to retrieve the data in the session table. But I have a combo box 'find' field for the clients based on ContactID which shows the first and last names of the clients. The anonymous sessions come up as a series of blanks in this list. Is there a better way to design this database or is there a way to get the blanks out of the find list?

 

[Rolliee]

Build a table with the Names and a chkbox for 'anon.' Then you can link their real name or just anon? with the ? a number. If anon is not checked, use the real name. If is checked use some version of 'anon??'

Rollie E