On 2008-05-12 02:28:45 -0400, Helpful Harry
<helpful_harry@[EMAIL PROTECTED]
> said:
Thank you for advice. I am sorry I have writen back for I was laid up
with neck surgery. I still have not looked at the solution closely due
to neck constraints but I do appreciate your reply and am sorry I did
not reply sooner. Thank you,
Steve
> In article <2008050609272316807-steve@[EMAIL PROTECTED]
>, Steve Berebitsky
> <steve@[EMAIL PROTECTED]
> wrote:
>
>> 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.
>
> I would guess that you've set the Value List to use the ID field and
> display the Company Name field. Although the pop-up menu / list will
> display the second Company Name field, it won't actually store that in
> the field - it only stores the first value (ie. the ID).
>
> What you can do is create another Relation****p between the CaseName and
> Company Tables based on this ID field. Then you can use this
> Relation****p to automatically retrieve the Company Name in the CaseName
> Table.
> eg.
> CaseNameTable_CompanyName
> = NewRelation****p::CompanyTable_CompanyName
>
> This is usually best as an unstored Calculation field or an Auto-enter
> by Calculation that re-calculates, otherwise it won't update itself if
> the ID is changed.
>
>
>
>> 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).
>
> You can't add new companies to the Company Table via a pop-up menu /
> list field in the CaseName Table. You will have to create new records
> in the Company Table itself first, and then they should appear in the
> Value List.
>
> You could have a Global field(s) in the CaseName Table and then run a
> Script to create the new Company record.
>
> Helpful Harry
> Hopefully helping harassed humans happily handle handiwork hard****ps
;o)
--
|
