Jump to content

Partial serial number?


This topic is 4417 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

Then I would suggest you add a Shipping table and create a related record there whenever an invoice is shipped. You can do this automatically, for example by keeping the shipping address in the Shipping table and allowing creation of related Shipping records in the relationship's definition.

Link to comment
Share on other sites

This topic is 4417 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.