Simple question about relational DB 
Author Message
 Simple question about relational DB

I1ve got a DB much similar to the examble in the FM "Users Guide" (FMP 4.1
p.10-36 ff) with a Customer file, a Invoice file, a Line Items file and a
Product file. My question is this: Is it possible to make new records in the
Product file from the Invoice file? When I1m in the Invoice file entering
data in the fields in the Line Items portal I can1t enter any new products
(Product ID, Product Name) - I1ll have to go to the Product file and enter
them and subsequently go back to the Invoice file and enter the Product ID
whereupon everythings fine... Is there any ways where I could do this from
the Invoice file?

/Jacob Baek



Mon, 25 Aug 2003 00:40:53 GMT
 Simple question about relational DB

In the invoices file, check the relationship to the products file, make sure
allow creation of related records is enabled.

Brian


wrote on 3/7/01 8:40 AM:

Quote:
> I1ve got a DB much similar to the examble in the FM "Users Guide" (FMP 4.1
> p.10-36 ff) with a Customer file, a Invoice file, a Line Items file and a
> Product file. My question is this: Is it possible to make new records in the
> Product file from the Invoice file? When I1m in the Invoice file entering
> data in the fields in the Line Items portal I can1t enter any new products
> (Product ID, Product Name) - I1ll have to go to the Product file and enter
> them and subsequently go back to the Invoice file and enter the Product ID
> whereupon everythings fine... Is there any ways where I could do this from
> the Invoice file?

> /Jacob Baek



Mon, 25 Aug 2003 03:08:54 GMT
 Simple question about relational DB

Quote:
> In the invoices file, check the relationship to the products file, make sure
> allow creation of related records is enabled.

> Brian


> wrote on 3/7/01 8:40 AM:

>> I1ve got a DB much similar to the examble in the FM "Users Guide" (FMP 4.1
>> p.10-36 ff) with a Customer file, a Invoice file, a Line Items file and a
>> Product file. My question is this: Is it possible to make new records in the
>> Product file from the Invoice file? When I1m in the Invoice file entering
>> data in the fields in the Line Items portal I can1t enter any new products
>> (Product ID, Product Name) - I1ll have to go to the Product file and enter
>> them and subsequently go back to the Invoice file and enter the Product ID
>> whereupon everythings fine... Is there any ways where I could do this from
>> the Invoice file?

>> /Jacob Baek

I'm sorry to say that this is not the solution... The Product file is not
updated this way - I can type whatever I want in the Line Items portal in
the Invoice file, but the Product file will remain as if nothing has
happened.
About 50 % of the products are newcomers (about 200 pieces a week) so it
would be much easier if all the typing could be done from one file...
Any other suggestions?

Thanks.

Jacob



Mon, 25 Aug 2003 18:08:06 GMT
 Simple question about relational DB
Hi Jacob -

If I am correct that you are trying to add a new product to ProductsDB whenever you
enter a new lineitem in your portal in InvoiceDB that does not already exist in
ProductsDB, I know of no way for you to do it through the portal, since it's not a
portal to Products.  However, I once created a scripted routine that did this.  If
you put a button in the portal row, you can use it to go to the related record you
just created in LineItemsDB, reduce LineItemsDB to that record, go to Products and
perform a saved import which will create a new record from selected fields in the
LineItems record, effectively creating a new product, then return to InvoicesDB.
However, this is fairly complex as it involves scripts in all three databases
calling one another, and the new record in ProductsDB is unlikely to be very
complete.  Moreover, it must be done for each new product record in each invoice,
in real time.

Or, you could periodically find all the records in LineItems for which there is no
Product, and add them that way, but the method has its own downsides, among them
being that you could never take a record out of Products because it would keep
recreating itself.

If you decide to try this, I would be happy to help, but my advice is to create new
products in ProductsDB, as logic would seem to dictate.

Quote:

> > In the invoices file, check the relationship to the products file, make sure
> > allow creation of related records is enabled.

> > Brian


> > wrote on 3/7/01 8:40 AM:

> >> I1ve got a DB much similar to the examble in the FM "Users Guide" (FMP 4.1
> >> p.10-36 ff) with a Customer file, a Invoice file, a Line Items file and a
> >> Product file. My question is this: Is it possible to make new records in the
> >> Product file from the Invoice file? When I1m in the Invoice file entering
> >> data in the fields in the Line Items portal I can1t enter any new products
> >> (Product ID, Product Name) - I1ll have to go to the Product file and enter
> >> them and subsequently go back to the Invoice file and enter the Product ID
> >> whereupon everythings fine... Is there any ways where I could do this from
> >> the Invoice file?

> >> /Jacob Baek

> I'm sorry to say that this is not the solution... The Product file is not
> updated this way - I can type whatever I want in the Line Items portal in
> the Invoice file, but the Product file will remain as if nothing has
> happened.
> About 50 % of the products are newcomers (about 200 pieces a week) so it
> would be much easier if all the typing could be done from one file...
> Any other suggestions?

> Thanks.

> Jacob

--
Don't forget to remove the obvious spam block when replying.
I advocate making an address book entry and using it!  Thanks!


Thu, 28 Aug 2003 14:30:51 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Need relational Unix db with simple API, free or COTS

2. SQL7, SIMPLE SIMPLE SIMPLE question

3. Question of Relational DB

4. Relational db report question

5. Relational DB Question

6. Newbie Relational DB Question

7. Simple DB Question?

8. Simple Restore DB Question

9. Simple DB Design Question

10. An apparently simple question about ole-db and SQL Server

11. simple DB design question

12. An apparently simple question about ole-db and SQL Server


 
Powered by phpBB® Forum Software