Field Names the same

[bionicman]

I know this has to be simple, and i am probably just over thinking it, but for the life of me, i don't know what to do.

I get multiple reports each day that are in no way connected except for the fact that they are errors caused by our CSR's. However, some have the same fields as others. For instance, they all have a field called "Trip#". I have no way to rename the fields in the reports as they are run by someone else in an excel format. i then import them into Access. I have been doing it with seperate tables for each report, but would like to have them all on one form.

Because i think this is hard to explain, i have attached an image of what i would like it to look like. Ideally, i would want the records from my "Blank Vehicle Type" report to show up in that section on my form (make sense?). i know each would be their own record, so my "Incorrect Pharmacy Coding" section would be blank.

The only problem i am running into is that some of the fields share the same name. so i can't have multiple "sections" as i do in my image.

Any Ideas?

please be gentle, i am not an expert with Access

 

[Navyguy]

bionicman

I think that if you search you may find out that you can import your excel field(s) into any access field that you identify. (someone yank my chain back if I am wrong here). A simple example would be an excel source called First Name, you might import that into an access field GivenName. So Trip#, if not common to all records could be BlankTripNum and PharmTripNum. The label on your form can read what ever you want as long as the field names in the Tbl are different.

The other item I think, is that if you have separate tables, your "Blank" and your "Pharm" sections could be subforms and could be drawn from different tables. Another example might be a TblEmployees and a TblQualifications, on an FrmEmployeeData you could view or edit those both even though they come from different tables.

I am not sure how new you are to Access Databases, but I am quite new. I found the most help was learning about normalization. This forum is a great resource for a variety of topics and this is where I learned about normalization.

Helpful?....hope so

 

[russi]

Hi.
I am in need of something similar to what you were asking about.
Did you find a workable answer?

Thanks in advance, for your response.

Russ