Girard Aquino wrote:
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]
Hi All
Well Girard, I did not mean to imply that _you_ needed it, I just
thought it would be a good idea. Your clients may not pay for the
items, but someone does. It would seem to me to be a good idea to track
the cost and the inventory, for those who must keep the stock of
supplies.
Mostly I just would like to expand my ability to generate the data bases
that I would like do. You should pick and choose which parts you use,
but I think a fuller functional date base would be of wider interest to
this community.
Cliff
--
mailto: [email protected]
Clifton R. Liles "Software to the Stars" [email protected]
Pearland, TX 77581 [email protected] [email protected]
- Speaking for myself! Standard disclaimer applies. -
This address may *not* be used for unsolicited mailings.
Failure is not an option. It comes bundled with your Microsoft products.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
