Recent content by WetCoast

Maybe it's this one ?

This might be one way to do that.... I've come across it on a few forums..

Maybe a picture of your tables showing the relationships might help to understand what your goals are... ...but it sounds like you might need to do a little more "normalization'. For example, why do Table A and Table B hold the same fields? This LINK might help you understand Normalization...

Galaxiom, is this what you meant? RE: Table Normalization Have attached a sample of what I think you were getting at in your last post here. Would you mind taking a look and letting me now if I'm getting your drift? much appreciated! T

GalaxiomAtHome sorry for the delay... full house this weekend... Thank you for your response.... You've definitely given me some things to think on! Much appreciated! I've been in a vacuum so long it is hard to see any other way on my own. Your insight is welcome... The metric...

Please explain more about the structure of the other tables. These will most likely combine into a very small number. Do they have a lot of fields in common? Being that a picture is worth a 1000 words... I have attached a pic of the relationship view from access with the tables placed on it...

16:31 I think the main reason I am having a hard time is the examples that are out there are dealing with two or more separate tables. ie:the Category and Product combo box. If I only import the CodeKey33 spreadsheet, the info is in one table.... can relationships be created between columns and...

The spreadsheet looks straightforward. You would not import COMPCODE9D as it is derived from the other columns. (Did you look at all 4 sheets or just the component code?) Yes... I guess it is 'straight forward' to most... but not to me yet! (Which is why I am asking for help... haven't you...

I have attached an excel2007 workbook containing the 3 sheets that I would like to import into access2007. The tables are for a maintenance database I am working on. The tables attached are part of the VMRS (Vehicle Maintenance Records System). I need to be able to import the tables in such a...