Form based on query problems

[esu4edp]

I want to have a main form with several sub forms based on a query. The only problem I have is the query is based on several linked tables and the query has lots of fields from these table. When I try to design the form, I open up the field list and it says too many fields defined, I guess you can only have 255 fields. Any way around this, or a different way of accomplishing what I want to do?

 

[jdegeorge]

Without seeing your database I can only pose a few thoughts. Do you really need that many fields? Maybe your data needs to be normalized more. For example, if you have a table with fields like HOME NUMBER, WORK NUMBER, CELL PHONE, CAR PHONE, etc. you can change that to 1 field for NUMBER and another field for TYPE_ID, and then have a realtional table showing TYPE_ID and PHONE_TYPE. This could help significantly reduce the number of fields.

HTH! "Get it right the first time, that's the main thing..."

 

[jerseyboy]

I agree that it sounds like maybe your structure needs help. If I were creating a database the covered all of the items in a large store (Like HOME DEPOT for example) I probably wouln't have that many fields.

If you explain some about your databse goals maybe we could help you make your structure more efficient. That may get you to the end result quicker. Let us know! JerseyBoy
Remember: self-praise is no recommendation

 

[jerseyboy]

I agree that it sounds like maybe your structure needs help. If I were creating a database the covered all of the items in a large store (Like HOME DEPOT for example) I probably wouldn't have that many fields. (and there are thousands of items in a HOME DEPOT!)

If you explain some about your database goals maybe we could help you make your structure more efficient. That may get you to the end result quicker. Let us know! JerseyBoy
Remember: self-praise is no recommendation

 

[esu4edp]

this is a reporting database for a police department. It has informatin about the report, the victim, reporting person, witnesses, suspects, stolen property, stolen vehicles, descriptions of suspects and so on. I dont have any data in the database, if its possible and someone wants to look at, and give me some advise, that's great!

 

[jerseyboy]

If you send it to officeteach@yahoo.com I will try to look at it. JerseyBoy
Remember: self-praise is no recommendation