Duplicate Fields?

[Fredofthreads]

I know that databases are to minimize duplicate information or whatever, but i have a field for supplier and a field for manufacturer and 1 time out of 500 it is different. Is there maybe a function i can use in default value, or something so that i don't need to add the same name twice? Any suggestions would be helpful, Thanks.

 

[Remou]

Presumably you have a table of people (supplier, manuafacturere, etc) and a form for updating?

You can set the manufacturerID to the supplierID in the supplier after update event, or simply leave it null, except where it is not equal to the supplier. You would then use a query (view)* for all forms and reports. It is generally recommended that tables are not used directly, so this is in line with best practice.


------------
*

SELECT Nz(ManufacturerID,SupplierID,ManufacturerID) As Manufacturer ...

Or

SELECT IIf(IsNull(ManufacturerID),SupplierID,ManufacturerID) As Manufacturer ...

http://lessthandot.com

 

[PHV]

Remou, the correct syntax for NZ:
SELECT Nz(ManufacturerID,SupplierID) As Manufacturer

 

[Remou]

It has been a while, thanks

http://lessthandot.com