One to many relationships

[Ben Ball]

Is there something I should know about one to many relationships?

I have 2 portal windows where from one (my stock table) I copy records into my ordering table. But when attempting to add a third, I am having problems. I have ascript that should move records into the table, which I have tried to modify form another. But I feel I am missing something out that will make the relationship work.

I think the relationship needs looking at and also the script.

What I am trying to do is: when an item is ordered and then booked in, I can then move the item into another table, say delivery/invoice.

Please see the file attached.

Fasteners_4.zip

[IdealData]

Where's the file?

[Ben Ball]

its there, pressed the "go" button in my excitement

[bruceR]

You have password protected the file.

[Ben Ball]

You can select the guest account to get in. This has full access.

[bruceR]

OK, opened the file. It is a little unclear what you are trying to do. You say you want to move things between portals but the only button you have attached to the Orders portal is a delete button - and it works. As for the IT button in the Stock portal, you are passing the parameter "Item Ready" but your script doesn't handle that value, it only handles Delete and Take Stock. You're also using copy/paste to move data and it is generally better to use set field.

The whole purpose of a job is to order one fastener type? This seems to be the case but I'm surprised.

Basically what is all of this supposed to do?

[Ben Ball]

The intention of the database is to be able to select a variety of products, based upon conditional value lists. The stock portal will change dependant on the "fastener type" and "Headstyle" fields. From this I can select parts from a customer order, see if they are in stock, if they are not.

I can order them.(this already works). But what I also would like to do is, put them ready for delivery if the parts are in stock. Thus, committing a record into the delivery table. Or another table, such the same.

As I say, I have a script that will add and delete, but I can't seem to make it work for the other tables.

I am trying at the moment, to have records move the same way into the delivery table, as they do to the orders table.

I can't seem to get the script to work. Its probably simple, but I cannot see it.

I know I have'nt, yet, added the other buttons to the order table,ie move to delivery, because I cannot get the button/script (IT) to work. Thus, sending records to the delivery table.

To summerize.

1. Need to copy records from "stock" to "orders". (this works).

2. Need to copy records from "stock" to "delivery". This does not work.

3. I need to copy records from orders to delivery. I have't yet attempted this as I have'nt figured number 2.

Thankyou for yout time.

[bruceR]

Maybe you've tried some other things by yourself - but in the file you've posted, you have made no attempt at all to do the things you're talking about. The IT script passes a paremeter and you have NO handler for the parameter you have passed. So of course it doesn't do anything. So - you are asking not to have your scripts reviewed and debugged; but to have your scripts written for you completely.

[bruceR]

See attached,

Fasteners.zip

[Ben Ball]

Hi, the help there is much appreciated. This helps me understand (especially) with the bold guides within the script.

I apologise if it looks as if I have'nt attemtped solutions. I had just tried to clean the file up, before posting. It was pretty messy. If you would like I will send you my attempted versions.

I don't like to be perceived as freeloading.

I am trying to learn and any way I can teach what I know, I will. I am a Design Engineer with experience within many manufacturing environments.

From concept to completion. Filemaker database solutions are very powerfull. As I am seeing they can be adapted to many applications.

I again, apologise if the file I attached seemed no effort. Believe me. I lost a few more hairs trying. I have already had a lot of help and do not want to outstay my welcome. Watch this space. I will put some back in!

Thanks again.