Recent content by j_cocker

Anyone? Thanks.

Thanks a lot! That looks much tidier. I attached the latest version of the database diagram below. I will add various fields to the tables, but does the structure look correct now?

Yes - it is a quote. Yep, it makes sense and should work, but it is not as "clean" a solution as I was hoping for... My problem is that I was hoping that an assessment will point to (one or more) piece(s) of equipment, and they in turn will point to quotes for them. Using your solution will...

Makes sense - I'll change that. Was/am going to do that (+add many more fields to some of the tables - was just trying to get the relationships and structure correct at this stage). Missed that one - thanks. Agree - see my comment above. This is where I am/was really struggling... - Every...

I am a MS Access novice, and am looking to develop an application based on Access 2007/10: - It is meant for a government agency that is tasked with assessing clients needs for certain equipment. - The agency sends an assessor to meet the client and produce a report highlighting the...

Thanks for that. I hate the 2007 menus with a passion! Can't see myself ever inflicting a similar experience on a user of my application... I also have a license for 2003 which in my opinion looks better, so I may try that.

Sorry, I am new to this Access stuff... Do you mean tabs?

I am looking to create an application. I want it to have a menu (i.e. a few buttons) on the left of the screen with the rest of the screen providing the space for the various forms, depending on the menu choises made. My problem is that I want the menu to always remain visible - something...

That's good to know. I was getting quite worried with the growing number of tables... The Bookings table is meant to hold records for slots (i.e. sessions) booked for a child. So a parent/Payee can book a session (say Friday afternoon) for a child, either as a one-off or for a period (say a...

I am designing a database for an after school club(s), that should be able to handle (amongst others): - Keeping a record of the children + Personal details + Health details (allergies, special needs, etc) + Which school attending + Which after school centre attending...

Right - makes sense. Thanks again.

Prices shouldn't change more than once a year I would have thought. I guess this suggests that I should use probably you first solution?

Many thanks! All should now be sorted.

I am pretty new to all this Access stuff, so please bear with me... I am trying to get my head around a problem that's been bugging me when designing a database: - Say you have a DB for maintaining a record of product range, prices, orders, customers, inventory, etc - The price of...

Fantastic! Again, many many thanks for your help!