Search results

I fixed it!! what I did was just put all the information on an excel sheet and created a 1 table that I had to drastically modify, thanks again for all your help!!

the tables have anywhere from 100 to 300 record lines but each table has a "SSAN" field....In all of my forms I made a search box the finds the record based on the SSAN but its only looks at one table. The link is a screenshot of my current tables. You can see that all of them have a SSAN...

I am learning through trial and error about creating a database and now I'm stuck. I currently have 4 tables and 4 forms(which will grow). The forms are set up to pull data from the applicable table. Each table has numerous fields (no duplicates). I've also created a Form called "Main Menu" that...