By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,963 Members | 1,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,963 IT Pros & Developers. It's quick & easy.

access forms

P: 7
Hi there,
I'm trying to create a form from a database, don't have a lot of experience and am somewhat muddling my way through...
It is for a hospital, so we have specific 'Services' with 'Wards' assigned to each. We are trying to capture their orders for items, under a 'Type' and then the 'Item'.

If possible, I would like to be able to choose a Service (ie Orthopaedics) and then have a list of Wards (ie R3, S3 and Q3). Alternatively if they chose Critical Care - Burns, Emerg and ICU would be available as a Ward.

Next I would like to be able to have the Type options - Instrument, Tray, Linen & Other, and then each of the available items be populated.

I currently have tables with these all connected, I'm just trying to figure out if it is possible to create a form in this way? Happy for it to be subforms with a table?

Thank you!
Nov 11 '11 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 446
Hi Jo,
It's cricial that you get your data analysis right before you start designing forms. You seem to have the entities 'Services' and 'Wards', so as a first shot I would expect your database to contain tblServices and a tblWards.

My problem is that when I read your post, from the first example I can understand that a Ward can be referred to by a Ward Number (ie R3, S3 and Q3) but the second example they are referred to by description "Burns, Emerg and ICU" , which I could easliy mis-understand as being 'Services' ?.

Are Burns treated in more than one Ward?

Until I get that straight in my head I find it difficult to move on to the next stage. It would seem to me that each ward may be associated with multiple types of 'Instrument, Tray, Linen', or are you just interested in a count of each?

What is the purpose of your database? Is it is for Inventory purposes? If you are new to database design you should perhaps download and study one of the Template database that are availble for Access;- perhaps the Asset Tracking database.
S7
Nov 11 '11 #2

Expert 100+
P: 446
Jo
I have just re-read your post and I wrongly interpreted your requirements. You are trying to classify orders rather than listing inventory. It seems to me that you are going to have a table tblOrderDetails that may have fields like (OrderID, ItemID (or ItemDescrpition), ItemQuantity, ItemCost, ItemType, ItemService, ItemWard)

I can see that you are trying to make your ward-list be prefilterd depending upon the Service selected. Using your values then tblServices would be
ServiceID Service
1.... . . Orthopaedics
2.... . . Critical Care

Your tblWard would then be like;
WardID SID WardName
1 . . . . . 1 ... R3
2 . . . . . 1 ... S3
3 . . . . . 1 ... Q3
4 . . . . . 2 ... Burns
5 . . . . . 2 ... Emergency
6 . . . . . 2 ... ICU

The information would be available for each Order from a combo box. The query for cmbWard would have to be filtered by the After_Update event of cmbService.

Search for 'cascade filtering' in this site to learn more about this.

If you are new to this I still recommend looking at the template databases that can be downloaded for access.Try
http://office.microsoft.com/en-gb/te...001018459.aspx
There are other templates here that might better fit you requirement
S7
Nov 11 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.