Drew Jensen wrote:
Clifton Liles wrote:
Drew Jensen wrote:
Drew Jensen wrote:
Girard Aquino wrote:
Basically, what I want to happen is:
- client approaches staff and asks for supply
- staff enters ID number and if
- client already has an entry in database, staff just adds the
new supplies the client needs which goes to the SUPPLIES table
- client is not in database, staff creates a new entry in the
CLIENT table and enters supplies given accordingly.
I created a form using the wizard and set the SUPPLY as a sub-form
of the main form which uses the fields of the CLIENT table (e.g.
ID, FirstName, LastName). Now when I enter data in the ID, say
1234, if there is an existing entry under the Supplies table that
is associated with the primary key, in this case, ID in the CLIENT
table, the items show up on the form.
What I would like to happen is to have the FirstName and LastName
show up as well when an existing ID is entered in the form that is
already existing in the CLIENT table. It's kinda like a search
form, that tells you when there is an existing entry already. Do i
need to create a separate table that will duplicate the FirstName
and LastName fields so that they show up when an existing ID in
entered? Or should there be a separate form to do "searching" and
another one to enter new data?
Actually you are quite close to having what you want. There is a
problem with your tables with regards to the relationship link
between them but after that most of the functionality you want is
already thee in the Base application.
Hi Drew and others
.... I do have a comment on the DB design. If I was doing this I
would like a third table of supplies.
something like this; Name, quantity, reorder level, cost, comments.
In your 'Dispense Supplies' Item should allow one to select one of
the items in the 'Supplies' table,
it should decrement the quantity
maybe do something if the count is below the reorder level.
As it is ...you could get several different names for one item
I found that if you go back and look at an old record the filed is
blanked.
What I would like is , if the field has a value, that value should be
displayed, if there is no value, then a drop down list of values.
Hi Cliff,
A very sound set of requirements.
What do you think Girard?
Is this the first (next) change you would make to this database?
Best Wishes,
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Well, it depends on the needs really. I read through that post and it
seems there is a different need. Like for my purposes, my database is
for a shelter which does not necessarily have to monitor stock of
supplies - just how many and what were given to a particular client. So
again, there is no need for cost in my case since they don't pay for the
items. What we needed to accomplish is making sure that people aren't
asking us for razors everyday for example.
Oh and I did read on doing macros and it's seems to be a good idea as well.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
