Search results

I see what you mean, it should be a one-to-one relationship though, not sure if I forgot to implement that in the example. The reason I want this number to be generated automatically is so that I can go straight into the inner-most subform without having to generate the TenderProjectID first...

Here is an example which hopefully better illustrates what I'm trying to do. This might not be the best way of doing things but is the only way I could think of (don't forget I'm new to this). As you can see when accessing the subform within 'Tender Projects Data Entry', the linked...

Is there a way to do it without adding another field? In the larger db this subform is only used to contain another subform which uses the generated TenderProjectID.

Thanks! Here's a sample db which illustrates the problem. In the Project Data Entry form, when a ProjectName is added, it generates a ProjectID and adds this to the Tender Projects Data Entry subform. When entering the subform, it's not possible to actually add the record since it doesn't...

Hi all, I'm new to the Access world and to this site, so please forgive my lack of knowledge. I currently have a form 'Project Data Entry' in which one enters project data - this form automatically generates a ProjectID. The 'Project Data Entry' form includes a subform 'Tender Projects Data...