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.
http://baseanswers.com/downloads/oooSupplies_mailinglist.odb
Hello again Girard,
Well - I hope that you had a chance to look at that database and the
single form in it.
In my last email I said that it was not the 'real' email I wanted to
send - actually it may not be an email I was thinking of at all.
I hope you don't mind but I've used your query to 'prompt myself' into
working on a presentation regarding Base and using your specific
question as the subject.
Putting together the presentation is going to take 'a couple of days'
at least and rather then just let you sit in silence during this time
- I'll put the file on-line and update it as I go.
http://baseanswers.com/downloads/oooSupplies_search_filter.odp
So - I'll be updating the file more tonight and will put another email
here as I update the on-line copy.
But - if you look at it now or later and use it to trigger questions
via the list - then I can answer the questions here and update the
presentation as needed.
Thanks
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Hi Drew and others
I have looked at your presentation and the database, you sent in a later
email, and it looked good to me. Thank you for your effort. I do have
a comment on the DB design. If I was doing this I would like a third
table of supplies. The table should look 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, and it should decrement the quantity and maybe do something if
the count is below the reorder level. As it is if there were more that
one person doing this or one person with a poor memory you could get
several different names for one item ( cleanser, soap, etc.), which
would make it hard to keep inventory.
I know you can do something like this. When I tried it, 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.
Thanks
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]
