making a form for meds

[drrobinv]

Okay, I'm pretty new at access. I have made tables for medication samples and sign out. I need some help in making a form to input and "sign out" meds.

I made the tables and allowed the wizard to create a form for me but I have some tables that don't show a relationship, and am not sure what to do.

The two forms I want are a data entry form that will enter the med, dose, lot#, exp. date, and number of samples for sign in, and, a form to enter date, patient last and first name, med, dose, lot #, expiration date, #of samples given, clinic and practitioner. I have attached the tables I made, can someone review and see if I messed up somewhere???? Thanks alot, I'm all for making our work lives easier! Robin.

 

[drrobinv]

reattaching forms

Yes, I guess it would help if I actually were able to "attach" the tables for viewing-sorry. I have fixed the relationship problems though.

Okay, it won't let me upload the tables, they are mdb files. Any ideas of how to get tables imported?? I know I have done it in the past....Robin

 

[jrjr]

Use Winzip to 'Zip' them. Then they can be attached to the post.

 

[drrobinv]

tables now posted

You guys are always so helpful to those of us who are challenged by access. Attached are my zipped tables. Thanks!! Robin.