finding/replacing shortcut help with subforms please help

[yepwingtim]

So i made a demographics table for the person's last name and first name. I have around 300 names already.
my primary key is the id

my new subform history table that i made today consist of the person's history.

The problem I have now is everytime I go to the subform history table and enter some data, I have to go back to the demographics table to search and find the person's name. When i hit ctrl+f it only searches the subform history table (how frustrating).

I need a way where the person's last and first name goes to the subform history table or need a better method of finding

i included a pic here... i know its a mess... sorry
http://img136.imageshack.us/my.php?image=testcf5.jpg

Thanks guys~
Danielle
________
Buy Herbalaire

 

[georgedwilkinson]

Hmmm...looking at your example I clearly see the Patient's name. Why do you say you have to go somewhere else to find it?

Also, it looks like your subform might not be correctly linked to the main form. Typically, you wouldn't show "ID" (that's not a good name for a FK) on the subform since it is clearly visible on the main form.

I assume you have the search & replace wizard up for some reason, possibly to help describe your problem. It may be interesting to you to know that I never, ever open that wizard, so I'm not sure why you would. Seems you're trying to find something but I don't know what.

Also, I just noticed what might be your problem: don't enter data directly into tables! Use a form, like the one displayed. It will help keep all the relationship stuff aligned and makes lookup of foreign key data simpler.

 

[yepwingtim]

Sorry george maybe I didn't explain this clearly
When i go to the history window and type up the information i need to type - i need to click on demographics window and hit ctrl+f to find the next person. What i want to do and would be really easily for me is hitting ctrl+f at the history window and searching for the person's name from there.

IE lets say Im at the demographics table I find the person's name David Williams and I have to type up his history up.
Right after i'm done typing up david williams history, I have to type up Maria Lopez history.
Here is the problem... I have to go back up to the demographics with my mouse cursor and hit ctrl+f to find Maria Lopez. Where as I just want to hit ctrl+f in the history table to find Maria Lopez.
________
MAKE A VAPORIZER

 

[georgedwilkinson]

Don't use <ctrl> F...use filter. Easiest way is to right click in the field you want to filter on and type your filter criteria in the Filter box. I've tried all kinds of statements in there that seem to work...just about anything you can put in a where clause about a field.

Also, I'm not sure why you have a history table and a demographics table, so my advice may be totally invalid. But it sounds like there could be ramifications and possibly even some opportunities to further normalization.