Creating a form for a table with two or more external references

[asarch]

Let’s say you have:

create table distro (
    id serial primary key,
    name varchar
);

create table arch (
    id serial primary key,
    name varchar
);

create table installation (
    id serial primary key,
    distro_id integer references distro(id) on delete cascade on update cascade,
    arch_id integer references arch(id) on delete cascade on update cascade,
    ...
);

How could you create a form for the installation table?

[RobertG]

distro_id and arch_id will be filled by listboxes. So create a form by wizard, change the field to listboxes and set SQL code like
SELECT "name", "id" FROM "distro" ORDER BY "name"