EntryLevel

Yes they have to be consecutive.

Ok this should be easy... I have invoices table there are 2 ID's there, Invoice ID and then the shipping ID. These must be separate ID. Every invoice contains Invoice ID, so I just set that to auto serial number. However only some invoices have shipping ID. How can I get the shipping ID to be either empty or next value... the ID should autofill if I type something in the shipping address box. It should also autofill when clicked... How can I get this kind of serial to work, where it doesn't auto fill it and looks up the last record with some other than empty value in it and plusses one?

can't figure it out =(.

Hello Filemakers! I am trying to create a portal from pictures table to inventory table that contains only one switchable image (through a joint table - because some parts are going to use same picture, this way I will save memory). The problem is, portals don't work quiet the same with pictures and need some scripting I have no idea how to do... So I want a portal from the images table that has only one image at a time in it and next/previous/insert/export buttons below it, also below the picture portal I want to have a other portal to the image table, that would contain picture number and path to the image. This table also would have only one value at a time that would change according to the picture above. Also if it is possible to somehow get the picture path to insert automatically when you import the picture (I want to import the picture as a file and also get the path to separate field below it). Finally I do like the picture to 1) Enlarge if you click on image 2) Import image if you click on empty portal. As off now I can't even get step one, which is to get the portal to swap page so I could insert 2nd image to it. With next portal row command nothing happens... Thanks to anyone who can help with this.

I may take a pic later if I can't solve this but anyway the relationship is as follows: Company ID(Serial/Unique/not empty- number) -----< Companies ID (allow creation)(number) (this is BTW named differently does that matter?) Then I also have primary key on the right hand side table that is set to be unique/ serial number/ not empty. I can't think of what could be wrong...

Hello! I have this very stupid issue that I can't solve. I have portal (one to many relationship), and well all the new records I add to the portal do not get added to the table for some reason. I have a other project where they do get added. All the data however DOES update if I change anything in the portal, just can't create new records (or if I have a button creating new record, it sill just stay empty in the table while I can add as much data to the portal as I want.) What is up here? There must be some option that I am not seeing. I have looked at 2 different projects like this and they seem exactly the same, yet there is a big difference... to be exact portal settings and relationship settings (allow creation of new records/deletion) are the same...