Search results

Is there a way I can set it up so that it won't let me duplicate and AssetID on my tblAsset?

Got it. Thanks.

I'm sure Ill be back with queries and reports.

There are multiple samples, so I like the continuous form on the frmSampleSub. There is only one result from each sample on the frmResultssubs, so I like the single form on that one. I think I can clean up my main form and make it easier to see. One thing I have noticed is if I click the...

I think I see what you did. So now to see the results from the different tests, I switch the record in the frmSampleSub. I get it. Since I'm doing it this way, can I change frmLeadResulsSub and frmAsbestosResultsSub from continuous to single form without tearing it up? It's only going to...

Ah, you changed the master on the frmLeadResultsSub to the control in the yellow text box?

I see it, but I don't understand it. Where do I put the results for SampleIDPK3 on yours? Are you telling me to put the formula in the unbound control somewhere on mine?

If my LeadSampleIDFK and my AsbSampleIDFK matched my SampleIDPK, I'd be there I think. I'm getting all 2s.

No, now it's not working. Ok, now it's picking it up, but it's assigning all the LeadSampleIDFK to the same SampleIDPK on that asset. If you look at yours, it has 2 tests: SampleIDPK 2 and 3. Both Lead tests. When I put in the results in the other sub, the LeadSampleIDFK is 2 for both of them...

Ok, now it's picking it up, but it's assigning all the LeadSampleIDFK to the same SampleIDPK on that asset. If you look at yours, it has 2 tests: SampleIDPK 2 and 3. Both Lead tests. When I put in the results in the other sub, the LeadSampleIDFK is 2 for both of them. See what I mean? The...

I think I followed your instructions to the letter, but I'm not getting your results. I did make the SampleFor table and put the cboBox and that is working. My leadSampleIDFK is not picking up the SampleIDPK. Was I supposed to change the child as well?

Many thanks Mike. I'll try that later today or tomorrow. I'm bowed up today as we say here. I appreciate it.

I have built my main form frmInput. My Sample Sub, frmSampleSub, and my two results subs-frmLeadResultssub and frmAsbestosResultssub. My frmLeadResultssub is picking up the AssetIDPK in the LeadSampleIDFK fine. So it is associated with the Asset. What the result is not associated with the...

Mike, I don't see how to add a new Asset?

Thanks GPGeorge. I'll be back when I get the forms figured out. I'm sure Mike's example will help me.

I didn't open the form, I was focused on the tables and relationships. I will look at it today. I can delete the Add New Test Type Command Button on the frmSampleSubform?

What am I missing Mike? What's different from yours?

Yes, I have looked at it. I was working on what I just posted when you sent that one. Mine looks very similar to yours, but some of the relationships on yours were off. Not linked to the corresponding fields. Understandable, given that I named them. I am burned out right now, I will look at...

This is what I have right now. I'm not sure how to test it.

I added one more: AssetType