Linking 5 Tables as Unable To Exceed 255 Rows

[bestfc01]

Hi All,

I been banging my head against a wall for the pass 2 weeks now and unable to solve getting passed this issue.

I have been asked to design a database to replace our old excel sheet to log one of our customers server builds. It a four noded system and i require a seperate log for each node serial models of parts etc, qa checks.

I intitial started by just using one table but forgot the limit was 255 rows, i need about 600 - 700. So my plan is now to transfer to indivial table for each node. Then, a general table named Main for all my other details.

Although this seems simple, i now have the annoying task of being able to link them all together and produce a single PDF file to send to our customer whilst only entering our system serial number once to produce this.

My basic understanding will be to create a System Serial Number field in each table a link it via relationships, but if i produce a report with everything i need would it input my details for all four nodes? If so how would i set this up?

I will be splitting the database once completed and then making a ACCDE file for my techs to use.

If anyone could give me so hel it would be more app

 

[gemma-the-husky]

you cannot just have a database table exactly the same as a spreadsheet tab. a spreadsheet is not normalised. the data in the spreadsheet needs re-arranging into a series of tables suitable for a database. this process is called normalisation.

this is not exactly hard, but is not trivial either, and difficult to do for a beginner. if this is for work, and you want to make quick progress, i would get some professional help - to at least explain the choices you will need to consider when going down the "access" route.

 

[bestfc01]

Thanks,

I am now creating single forms for each table, and when i need to send them to my customer link them all together to have 5 attachments rather than one.

 

[boblarson]

I intitial started by just using one table but forgot the limit was 255 rows,

Pat is correct. Follow her advice.

And just a point of correction for you. You are talking about COLUMNS not rows. Access tables can have millions of rows, but only 255 columns. And it is the RARE database, if designed properly, that has more than 30 or so columns.