Search results

No, I meant about the bad database design with the repeating information in tables.

I am totally willing to do what I should to fix it--what should I do?

I think the only thing duplicated in any of the tables is the client's name. Is that a problem? and maybe social security number

I'm not really sure I understand. We definitely need all the tables we have. Let me make sure I've been clear about what I'm trying to accomplish. We have several divisions that provide different services for clients. Each client has information in the Contact Info table. Then each division...

Actually, now that you ask me that, I might be able to expand my question a bit more. I have one table called Contact Info that has client name, social, address, phone, referral date, and a unique number we assign. The other table on the form has information on a service we provide, and it...

I have a form that pulls from two tables, but I want it to show records if there is data in either table, while as of right now it is only showing if data is in both. How do I change this?:confused: