Search results

Thanks for taking the time to look at it as well, I'll have a look & try to unpick it.

That's the same version I sent, I haven't made any changes & its still not working. But by the sound of it its a stupid glitch, so I'll try compacting the database, remaking the table and reload again or even starting from scratch with the back end. It's my problem now anyway. Thanks again...

where did you find the old links? I only have the one. The first thing I did was to clean it out

If you have time, please can you give me another nudge in the right direction? I'm recreating what you uploaded in my original database. Partly to learn what you did & partly to expand on what you started. I've made the JobContacts table & adjusted the relationships in the back end I've got...

Thank you for taking the time to do that... I'll now sit down & unpick it all to understand exactly what you did.

This was the old solution in excel... but it makes more sense to add the names dynamically so I can have x number of them That form was built on a cascade from client down, so you could only pick contacts from that client. But that in itself causes issues as people move around between companies.

The issue is that each site has a variable no of Contacts, a variable no of Directors & and Arch & Struc Eng. The contacts are employed by the client (but come & go across the different jobs. Big jobs often have several client contacts) Arch & Struc Eng can turn up on any job from any client

The intention is to create a table starting with a JobID that you can add contacts to

here you go

That's the backend. I haven't created a form to Add clients yet. I was trying to get my head around how to pull the info from the Tables to do that. I can upload the front end so far if that helps.

I may be being a bit slow, but I can't see where that's being recorded.

I've created that, but in my inexperience, I still can't see how that records which Jobs a contact is allocated to. I think I need a table with ContactID and JobID over many rows (tbl_Job is 1 row per job).

thanks... I've watched a video & had a stab, I'll look at your example as well before I go too far.

OK... Ill go to YouTube University & have a look. Thanks for the steer in the right direction.

I think I could use your roles table to link in the jobID? That would close that issue as well?

I have realised I don't think there's a way to record which contacts are involved with which job. I need a way to link the Job Back into Contacts. Or is my lack of knowledge making me miss a way to do it? I can also split Contacts down as you suggested to make it easier to control.

Please can someone give me a nudge in the right direction on the best way to design this form? I'm moving from a massive spreadsheet to Access & trying to upgrade how I do it as I go, but this is my first go at Access. Several people have already helped with the normalisation of the data etc &...

What was the right way to store them?

That's perfect, it resolves it correctly. I'll do it that way going forward. But what was wrong with it in the first place? What did I miss that meant it required the Eval function? Or is it a "because Access" sort of issue?