Search results

Thanks but I need that box to grow as there will be more information on some

Hi all, I am using my database to create product sheets for a lighting design company. Each product is bespoke and descriptions obviously change. I have created a report for a downlight and I am happy with the layout, but when I open the report in print preview mode, half of the fields have...

This is a good question - assuming the project itself has not changed, we would just add a revision to any documentation that we have produced if anything else had changed. As the house name/location/address/client is the same there is no reason for the existing projectID information to change...

Wait! I have changed my mind - I am going to use the ProjectID as the primary key. I am 100% certain that it will not/cannot be used again and it is meaningful data. I just need to write some code to automatically generate this number now... Thanks for all of your help, I will probably be back...

Thanks for this. The projectID will always be unique. If a project is cancelled etc then we don't re-use that number, just incase it starts up again or someone needs the drawing for future use. It is used to reference CAD drawing packages and designs as well as order references so removing it is...

Hi, complete novice here again, but I have a couple of questions about primary keys and the normalization of data. I work at a lighting design company and I want to increase productivity by creating lighting, circuit and switchplate schedules, product sheets, orders, invoices etc. but last...

Thanks! This is very helpful.

Thank you! I didnt realise the form had to be open.

Hi there, I am all very new to this and am slightly struggling with queries. A bit of background on the project I am currently working on - I am a lighting designer and I want to streamline creating lighting schedules and product specification sheets etc. We have several projects we are...