Wait, don't Ethernet cards have a hard-coded MAC address?
Not sure what you're trying to achieve.
But if you need to create complicated serial numbers for whatever reason scripting is the best way to do it.
agnes b. riley
filemaker and web development
TWO-TIME MAD DOG AWARD WINNER
FileMaker Certified in 10 and 11
Member, FileMaker Business Alliance
T: 877 917-9079 . C: 917-660-7221
Agnes is correct, the MAC address of all physical network connections (ethernet, wifi, etc.) are hard coded to the machine.
You can't assign a Mac address as others have already stated. The command Get ( SystemNICAddress ) will return the all of the Mac addresses on the computer. So you can run a script to pull the information for the computer you are working on and store that information in the database.
Yes MAC addresses are HARD CODED, We are a manufacturer of NETWORK enabled devices and have purchased 4096 MAC addresses from IEEE. We are using the FM database to assign and track the serial numbers and the MAC addresses of our products.
I was planning on scripting the MAC addresses, however I've gotten bogged down on the calculation to generate the next available MAC address using the HEX formatting.
There are several custom functions on Brian Dunning's CF site which will do conversions from one base to another, like this one:
So if you already have a base 10 serial number field, you can define a calc to return the base 16 equivalent of that.