Invoicing database--deleted product ID field and now the invoicing function is disabled
I am using the invoicing template from Filemaker Pro. In an attempt to customize it, I have deleted the product ID field which I don't need. I expected incorrectly for the Product name, price, etc to autofill as it did with the Product ID intact. Unfortunately, that is not the case. The field properties appear to be correct, but I suspect that it is a relational issue with the Catalog items. Anyway, if anyone can offer any help, that would be great.