Search results for query: *

I thought htis would be fairly simple, there I go thinking again! Anyway, I have a field called "ETR" in a table called NEWETR1 (this is a string in the format 2003-0001)that i want to increment whenever a new ETR is opened, or in this case whenever this form is opened and then have...

Yup, I think it need to hang off tblETR. ETR is a job number and yes, successive activities do cause new entries into tbl Log. As for the ETR Records, wern't they for Log entries?

The users want a Log entry generated whenever and entry is made into an ETR record. This is a way for them to look at say a particular shift and see what work was done vice calling up a particular ETR and read. Also not all jobs will have ETR's. For instance something that is done on a daily...

Sorry, I was wrong and herein lies my problem it looks like. There can be more then one entry in the Log on the same job with the same ETRRef. tblETR primary key is the ETR (Job) number (which there can only be ONE ETR number, but there also can be multiple entries for a particular ETR number...

Thanks for the help but I still have a problem. In tblLOG the ETRRef that you say to use as a foriegn key has to be indexed, this is a problem, there can be more then one entry in the Log on the same job with the same ETRRef? If two diferent techs work on the same piece of equipment 2 days in a...

Ok, guys here's where it gets a little strange. It's not just the memo field in the tblLog. The reason I see for 2 separate tables is that they need to be able to create just a Log Entry when they work on a piece of gear that does not have an ETR number (job number)and be able to keep separate...

I have somewhat of non-standard setup i would presume as this Maintenance DB is being updated from a flatfile DB. Basically, I have 2 tables one called tblETR and the other tblLOG. tblETR primary key is the ETR (Job) number with a one to one relationship to tblLOG.ETR. WHat I need to do is...