Recent content by access_novice1234567

I have a form which users use to record concerns. The form automatically generates a concern i.d. number as a field on the form. When the user enters the project name I have a lookup field which displays the name of the project manager. I want to send an automatic email to the project manager...

Hello. I have a form that users log product concerns on. When a new concern is logged, I want the manager of that product to be informed, automatically by email. In "Team" table I have all the products, managers and email addresses stored. In "ConcernInputForm" when the user inputs the project...

OK. So I now have my main table with lots of information, and my log number table which contains the result of my query, as a make table query. I now need to display fields from both tables in the one form, in datasheet view. I can't link the tables together to do this. Any more advice?

OK, got the query working now. Just got to get the query results back into my table. I take your point about data corruption, letting users touch the table, but got to trust people in the organisation not to fiddle with things.

Right. Log number needs to be stored in the table. I have two things that users are going to look at. A form where they input description of concerns. And then a table where they can search all the concerns that have been recorded. So data will only be entered through the form. However...

Sorry Rabbie, have no idea how to do this, and I am finding "help" to be no help at all. Would appreciate further guidance.

I need help. I want a field in my table that generates an Log number. I already have fields: I.D. number (sequential number) Project Name (Text field) Milestone (Number field) The Log number should be made up of the first two letters from the Project Name, then the Milestone, then the ID...