Recent content by RobHausler

Also PK = Primary Key but What is FK?

Sorry for my further ignorance.. But how would you then display them in a form for entry.. . Normally I would just lay out the fields on a form.. This way I would need to have embedded forms or reports no?

Aagh gentleman yes i do that with AgentID's, Advertising Sources, Product Codes, and many others.. My Problem is I am making a sales quotation system. The table holds the details of the Quote itself - I have to hold the sale price as at time of quotation as prices can change and the data will...

So by splitting the fields relivant to each page of teh quote system into seperate tables with the first field containing the Quote ID and a seperate table holding the quote id and customer data would be better - I wont claim best at this point. My concern will be when i go to make a tabbed...

i'VE GOTTEN TO 240 BY doing a compact and repair - but I still need more.

I get to Field 210 and it says "To Many Fields Defined" but from the spec's its meant to be 255.. Mind you Im going to probably need more than that, - so any thoughts ??

I have just started adding fields to a new table for a quotation tool and there are lots of fields - i think i have hit some limit - as it comes up with an error when i go to save the table.

Can someone please tell me the Maximum no of fields you can have in Access 2007 and if the limit is 255 then how can one get around this problem? Thank you,.