Forum Discussion
Form Combo Box Doesn’t Store Selected Value (Foreign Key Issue)
Hi all, I'm building a data entry form for the Peserta_Workshop table in Microsoft Access. This table includes a field called ID_Unit_Kerja, which is a foreign key referencing the Unit_Kerja tabl...
From your screenshot your table is provably called Unit Kerja Peserta so your SQL is invalid though I would have expected a different error message.
Two other points:
1. Table level lookup fields are not recommended.
2. Similarly avoid using spaces in object names. Either use underscores or just e.g. UnitKerjaPeserta