Hello everybody,
I am trying to build a database fo keep track of many different
variables regarding opening a cases of s****t cards. What this will do
is allow me to keep track of how many boxes in a case, how many packs
ina box and cards in a pack. From this I would like to be able to say
card xyz came from case #17, box # 4, pack # 5 and was the third card
in the pack. Included in this database would also be how much each card
is worth (based on historical data I would manually input).
I have written out my plan and cannot get past the first phase of
naming each case by their respective names. Here is what I have done (I
realize this may be overkill because it is for only me, but I am trying
to do things correctly) :
Made 4 tables:
Company (Topps, Upperdeck...)
company
kp_company_id (autoserial, not modifiable)
Brand (e.g., Bowman is owned by Topps)
brand
kp_brand_id (autoserial, not modifiable)
Product (Premiere, Exquisite...)
product
kp_product_id (autoserial, not modifiable)
CaseName (total combination of the above info)
year
::company_id
::brand_id
::product_id
total_case_name (concate the above info)
CaseName is where I want to focus my efforts. In CaseName I have been
trying to make the related fields come up as pop up menus where I will
be able to either choose an existing record or add one that will be
recorded and serialized by the related field. It seems very simple to
me but I cannot get it to work!
For example, I place a field in the CaseName layout, double click it,
display drop down list, display data from "Company", define value list,
specify "kp_company_id" also display "company" as second, show only
values in second, ok, ok, ok. Now I am on the "Field/Control Setup"
window. It is set to drop down list, Display value from "Company" ,
display data from 'Company'. I am unable to check the edit box for it
is grayed out. I go back to layout mode to see the field ::kp_comp_id
(also has an arrow to click on). I go to Browse mode, click on the
field and there are two problems:
1. When I click on the field, I see Topps, Donruss etc but when I let
go it regresses back to the id number.
2. I am unable to add records to this field (which in turn means I
cannot record new names as needed to the "Company" table via the
related "CaseName" table. (I went into Relation****ps and clicked on the
relation****p between 'company' and 'casename' and allowed the addition
of records via both. I left delete unchecked for no particular reason).
It seems so easy. I am missing something very small. I just do not know
what it is.
One more hint. I had to turn off "prohibit mod of serial number"
because I kept receiving a field not modifiable error.
Thank you so much,
Steve
|
