Recent content by Synses

You are such a great help, yes I see what you mean. For staff, should I make one staff table and insert a field on it for employer, either "client" or "NLI" ..? On the Lesson Learned form, my sister asked that the lesson learned be specific to facility - it is "how to do it right" data that...

Thanks, I am working on this and see/understand that what I think I don't really understand is how to make tables and then make relationships between tables. I think what you are saying is, for example, that these connections (between,client, facility, clientstaff, phone number) should be step...

Thank you Steve, you have been much more than generous and I appreciate it greatly!

Thank you for your patience. Lesson learned about navigating the messages! I had followed the excellent instructions/picture showing how to change the join lines, but it did not look like yours, it did not have the one to many symbols and I could not make them appear so I messaged you again...

Sorry, oops thought I did...

Meant to attach screen shot....this is where I am...

I can't figure out how to make the join look like the join in your picture. I got to the report Lesson Learned Query Builder but am stuck there....would you please tell me how to make it one to many from ClientFacilityId in tblClientFacility to clientFacilityIdFK in tblLessonLearned the way...

Thanks. That is exactly the kind of advice I need because I obviously am new to access and don't realize the consequences of doing some things that pros like you do and I appreciate you sharing your expertise. I will do that (cut out extra FKs) now and rethink how to do it. It also helps that...

I created my first report on a database that has tables with combo boxes and a related form. The main table the report is supposed to be on is the lesson learned table. The lesson learned table has three fields, client idfk, facilityidfk, and lesson learned. "Lesson learned" is entered with a...

Thanks, I eliminated the look ups and created a report. The problem with the report is that it shows lessons learned (that had been entered for one client, or for one facility) for all facilities of the client. (example: client Exelon) Is there a way to make it so that when the report...

Thnaks, for the 'Lesson Learned" data entered to be connected for user observation/review, in assocation with the Client and the Facility that the "lesson Learned" is about/the form user selected, I think that creating and generating a report is the way to do that without changing any current...

Thanks, I will get on that tomorrow!!!

THANK YOU SO MUCH! My error is that I was looking at the cboClientFacility properties, not the form properties. Thank you. I hope you are blessed enormously. Synthia

Thanks, I don't see an "On Current" event...do I need to create it? (how?) or did you maybe mean "On Change" ? Thank you,Synthia

Right now the form feeds info from the lesson learned field on the form to the Lesson Learned table. (I incorrectly stated that it fed info to the "Faciltiies tables" in my question, there are no "Facilities tables" ther is one "Client Faciliies" table). There is one Client table (lists all...